class DeptMapper:
    GET_DEPT = """SELECT `dept_id` FROM `aoa_dept` WHERE dept_name='{dept}'"""
    
    ADD_DEPT = """INSERT INTO `aoa_dept`(`dept_id`, `dept_hierarchy`, `dept_name`)
    VALUES ({dept_id},2,'{dept}')"""
    
    DEPT_LIST = """SELECT * FROM `aoa_dept`"""
